/*
 Navicat Premium Data Transfer

 Source Server         : 172.16.24.150
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 172.16.24.150:3306
 Source Schema         : viewer

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 24/10/2020 12:36:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for position_info_v2
-- ----------------------------
DROP TABLE IF EXISTS `position_info_v2`;
CREATE TABLE `position_info_v2` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '职位ID',
  `company_id` int(11) DEFAULT NULL COMMENT '公司ID',
  `company_code` varchar(255) DEFAULT NULL COMMENT '公司code',
  `postion_name` varchar(255) DEFAULT NULL COMMENT '职位名称',
  `position_code` varchar(255) DEFAULT NULL COMMENT '职位code',
  `position_city` varchar(255) DEFAULT NULL COMMENT '职位城市',
  `position_salary` varchar(20) DEFAULT NULL COMMENT '职位薪水',
  `work_year` varchar(20) DEFAULT NULL COMMENT '工作年',
  `edu` varchar(20) DEFAULT NULL COMMENT '教育程度',
  `postion_type_name` varchar(20) DEFAULT NULL COMMENT '职位类型名称',
  `position_type_code` varchar(20) DEFAULT NULL COMMENT '职位分类code',
  `position_boss` varchar(20) DEFAULT NULL COMMENT '发布人',
  `position_boss_type` varchar(20) DEFAULT NULL COMMENT '发布人职位',
  `position_update_date` varchar(20) DEFAULT NULL COMMENT '发布日期',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '插入',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of position_info_v2
-- ----------------------------
BEGIN;
INSERT INTO `position_info_v2` VALUES (1, 1, '0001', 'CTO', '03', '北京', '30-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:12:44');
INSERT INTO `position_info_v2` VALUES (2, 1, '0001', 'CTO', '03', '北京', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:13:06');
INSERT INTO `position_info_v2` VALUES (3, 2, '0002', 'CTO', '03', '上海', '30-45k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:13:14');
INSERT INTO `position_info_v2` VALUES (4, 3, '0003', '销售总监', '04', '杭州', '40-60k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:13:22');
INSERT INTO `position_info_v2` VALUES (5, 4, '0004', 'golang', '01', '北京', '20-30k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:13:35');
INSERT INTO `position_info_v2` VALUES (6, 1, '0003', '销售总监', '04', '北京', '20-30k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:13:42');
INSERT INTO `position_info_v2` VALUES (7, 1, '0005', '技工', '10', '北京', '2-4k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:13:55');
INSERT INTO `position_info_v2` VALUES (8, 1, '0001', 'CTO', '03', '北京', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:14:08');
INSERT INTO `position_info_v2` VALUES (9, 1, '0001', 'CTO', '03', '北京', '15-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:14:18');
INSERT INTO `position_info_v2` VALUES (10, 1, '0001', 'CTO', '03', '北京', '15-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:14:31');
INSERT INTO `position_info_v2` VALUES (11, 2, '0002', 'CTO', '03', '北京', '15-40k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:14:38');
INSERT INTO `position_info_v2` VALUES (12, 3, '0003', '销售总监', '04', '北京', '40-60k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:14:43');
INSERT INTO `position_info_v2` VALUES (13, 4, '0004', 'golang', '01', '北京', '20-40k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:14:50');
INSERT INTO `position_info_v2` VALUES (14, 1, '0003', '销售总监', '04', '北京', '20-40k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:14:56');
INSERT INTO `position_info_v2` VALUES (15, 1, '0005', '技工', '10', '北京', '2-3k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:15:02');
INSERT INTO `position_info_v2` VALUES (16, 1, '0001', 'CTO', '03', '北京', '10-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:15:11');
INSERT INTO `position_info_v2` VALUES (17, 1, '0001', 'CTO', '03', '北京', '10-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:15:19');
INSERT INTO `position_info_v2` VALUES (18, 1, '0001', 'CTO', '03', '上海', '10-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:15:21');
INSERT INTO `position_info_v2` VALUES (19, 2, '0002', 'CTO', '03', '上海', '20-50k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:15:28');
INSERT INTO `position_info_v2` VALUES (20, 3, '0003', '销售总监', '04', '上海', '20-50k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:15:34');
INSERT INTO `position_info_v2` VALUES (21, 4, '0004', 'golang', '01', '上海', '20-50k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:15:37');
INSERT INTO `position_info_v2` VALUES (22, 1, '0003', '销售总监', '04', '上海', '20-50k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:15:39');
INSERT INTO `position_info_v2` VALUES (23, 1, '0005', '技工', '10', '上海', '3-5k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:15:45');
INSERT INTO `position_info_v2` VALUES (24, 1, '0001', 'CTO', '03', '上海', '10-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:16:00');
INSERT INTO `position_info_v2` VALUES (25, 1, '0001', 'CTO', '03', '上海', '10-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:16:02');
INSERT INTO `position_info_v2` VALUES (26, 1, '0001', 'CTO', '03', '铜仁市', '10-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:16:06');
INSERT INTO `position_info_v2` VALUES (27, 2, '0002', 'CTO', '03', '铜仁市', '10-30k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:16:07');
INSERT INTO `position_info_v2` VALUES (28, 3, '0003', '销售总监', '04', '铜仁市', '10-30k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:16:14');
INSERT INTO `position_info_v2` VALUES (29, 4, '0004', 'golang', '01', '铜仁市', '3-10k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:16:20');
INSERT INTO `position_info_v2` VALUES (30, 1, '0003', '销售总监', '04', '铜仁市', '2-10k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:16:27');
INSERT INTO `position_info_v2` VALUES (31, 1, '0005', '技工', '10', '铜仁市', '3-8k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:16:33');
INSERT INTO `position_info_v2` VALUES (32, 1, '0001', 'CTO', '03', '铜仁市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:16:39');
INSERT INTO `position_info_v2` VALUES (33, 1, '0001', 'CTO', '03', '铜仁市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:16:44');
INSERT INTO `position_info_v2` VALUES (34, 1, '0001', 'CTO', '03', '昆明市', '23-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:17:03');
INSERT INTO `position_info_v2` VALUES (35, 2, '0002', 'CTO', '03', '昆明市', '14-20k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:17:25');
INSERT INTO `position_info_v2` VALUES (36, 3, '0003', '销售总监', '04', '昆明市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:17:31');
INSERT INTO `position_info_v2` VALUES (37, 4, '0004', 'golang', '01', '昆明市', '3-5k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:17:35');
INSERT INTO `position_info_v2` VALUES (38, 1, '0003', '销售总监', '04', '昆明市', '30-40k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:17:43');
INSERT INTO `position_info_v2` VALUES (39, 1, '0005', '技工', '10', '昆明市', '53-100k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:17:53');
INSERT INTO `position_info_v2` VALUES (40, 1, '0001', 'CTO', '03', '昆明市', '33-100k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:18:03');
INSERT INTO `position_info_v2` VALUES (41, 1, '0001', 'CTO', '03', '昆明市', '30-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:18:10');
INSERT INTO `position_info_v2` VALUES (42, 1, '0001', 'CTO', '03', '成都市', '100-200k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:18:16');
INSERT INTO `position_info_v2` VALUES (43, 2, '0002', 'CTO', '03', '成都市', '140-200k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:18:23');
INSERT INTO `position_info_v2` VALUES (44, 3, '0003', '销售总监', '04', '成都市', '115-200k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:18:32');
INSERT INTO `position_info_v2` VALUES (45, 4, '0004', 'golang', '01', '成都市', '30-40k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:18:38');
INSERT INTO `position_info_v2` VALUES (46, 1, '0003', '销售总监', '04', '成都市', '330-500k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:18:46');
INSERT INTO `position_info_v2` VALUES (47, 1, '0005', '技工', '10', '成都市', '53-100k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:18:52');
INSERT INTO `position_info_v2` VALUES (48, 1, '0001', 'CTO', '03', '成都市', '33-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:19:02');
INSERT INTO `position_info_v2` VALUES (49, 1, '0001', 'CTO', '03', '成都市', '32-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:19:07');
INSERT INTO `position_info_v2` VALUES (50, 1, '0001', 'CTO', '03', '重庆市', '23-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:19:12');
INSERT INTO `position_info_v2` VALUES (51, 2, '0002', 'CTO', '03', '重庆市', '10-20k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:19:21');
INSERT INTO `position_info_v2` VALUES (52, 3, '0003', '销售总监', '04', '重庆市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:19:27');
INSERT INTO `position_info_v2` VALUES (53, 4, '0004', 'golang', '01', '重庆市', '3-5k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:19:40');
INSERT INTO `position_info_v2` VALUES (54, 1, '0003', '销售总监', '04', '重庆市', '33-44k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:19:48');
INSERT INTO `position_info_v2` VALUES (55, 1, '0005', '技工', '10', '重庆市', '53-80k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:19:55');
INSERT INTO `position_info_v2` VALUES (56, 1, '0001', 'CTO', '03', '重庆市', '30-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:01');
INSERT INTO `position_info_v2` VALUES (57, 1, '0001', 'CTO', '03', '重庆市', '3-8k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:06');
INSERT INTO `position_info_v2` VALUES (58, 1, '0001', 'CTO', '03', '重庆市', '2-3k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:12');
INSERT INTO `position_info_v2` VALUES (59, 2, '0002', 'CTO', '03', '重庆市', '2-4k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:20:19');
INSERT INTO `position_info_v2` VALUES (60, 3, '0003', '销售总监', '04', '重庆市', '2-8k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:20:27');
INSERT INTO `position_info_v2` VALUES (61, 4, '0004', 'golang', '01', '重庆市', '5-10k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:20:33');
INSERT INTO `position_info_v2` VALUES (62, 1, '0003', '销售总监', '04', '重庆市', '33-40k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:40');
INSERT INTO `position_info_v2` VALUES (63, 1, '0005', '技工', '10', '重庆市', '33-40k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:49');
INSERT INTO `position_info_v2` VALUES (64, 1, '0001', 'CTO', '03', '重庆市', '33-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:52');
INSERT INTO `position_info_v2` VALUES (65, 1, '0001', 'CTO', '03', '重庆市', '33-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:55');
INSERT INTO `position_info_v2` VALUES (66, 1, '0001', 'CTO', '03', '乌鲁木齐市', '33-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:20:58');
INSERT INTO `position_info_v2` VALUES (67, 2, '0002', 'CTO', '03', '乌鲁木齐市', '10-20k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:21:03');
INSERT INTO `position_info_v2` VALUES (68, 3, '0003', '销售总监', '04', '乌鲁木齐市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:21:09');
INSERT INTO `position_info_v2` VALUES (69, 4, '0004', 'golang', '01', '乌鲁木齐市', '10-20k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:21:16');
INSERT INTO `position_info_v2` VALUES (70, 1, '0003', '销售总监', '04', '乌鲁木齐市', '10-20k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:19');
INSERT INTO `position_info_v2` VALUES (71, 1, '0005', '技工', '10', '乌鲁木齐市', '10-20k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:21');
INSERT INTO `position_info_v2` VALUES (72, 1, '0001', 'CTO', '03', '乌鲁木齐市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:22');
INSERT INTO `position_info_v2` VALUES (73, 1, '0001', 'CTO', '03', '乌鲁木齐市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:24');
INSERT INTO `position_info_v2` VALUES (74, 1, '0001', 'CTO', '03', '沈阳市', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:30');
INSERT INTO `position_info_v2` VALUES (75, 2, '0002', 'CTO', '03', '沈阳市', '20-30k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:21:36');
INSERT INTO `position_info_v2` VALUES (76, 3, '0003', '销售总监', '04', '沈阳市', '20-30k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:21:39');
INSERT INTO `position_info_v2` VALUES (77, 4, '0004', 'golang', '01', '沈阳市', '20-30k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:21:42');
INSERT INTO `position_info_v2` VALUES (78, 1, '0003', '销售总监', '04', '沈阳市', '20-30k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:44');
INSERT INTO `position_info_v2` VALUES (79, 1, '0005', '技工', '10', '沈阳市', '20-30k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:46');
INSERT INTO `position_info_v2` VALUES (80, 1, '0001', 'CTO', '03', '沈阳市', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:51');
INSERT INTO `position_info_v2` VALUES (81, 1, '0001', 'CTO', '03', '沈阳市', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:21:59');
INSERT INTO `position_info_v2` VALUES (82, 1, '0001', 'CTO', '03', '保定市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:22:05');
INSERT INTO `position_info_v2` VALUES (83, 2, '0002', 'CTO', '03', '保定市', '10-20k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:22:15');
INSERT INTO `position_info_v2` VALUES (84, 3, '0003', '销售总监', '04', '保定市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:22:16');
INSERT INTO `position_info_v2` VALUES (85, 4, '0004', 'golang', '01', '保定市', '2-9k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:22:20');
INSERT INTO `position_info_v2` VALUES (86, 1, '0003', '销售总监', '04', '保定市', '3-10k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:22:26');
INSERT INTO `position_info_v2` VALUES (87, 1, '0005', '技工', '10', '保定市', '4-10k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:22:29');
INSERT INTO `position_info_v2` VALUES (88, 1, '0001', 'CTO', '03', '保定市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:22:33');
INSERT INTO `position_info_v2` VALUES (89, 1, '0001', 'CTO', '03', '保定市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:22:35');
INSERT INTO `position_info_v2` VALUES (90, 1, '0001', 'CTO', '03', '西安市', '2-10k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:22:42');
INSERT INTO `position_info_v2` VALUES (91, 2, '0002', 'CTO', '03', '西安市', '10-20k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:22:51');
INSERT INTO `position_info_v2` VALUES (92, 3, '0003', '销售总监', '04', '西安市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:22:54');
INSERT INTO `position_info_v2` VALUES (93, 4, '0004', 'golang', '01', '西安市', '10-20k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:22:56');
INSERT INTO `position_info_v2` VALUES (94, 1, '0003', '销售总监', '04', '西安市', '10-20k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:22:58');
INSERT INTO `position_info_v2` VALUES (95, 1, '0005', '技工', '10', '西安市', '50-80k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:23:03');
INSERT INTO `position_info_v2` VALUES (96, 1, '0001', 'CTO', '03', '西安市', '50-80k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:23:11');
INSERT INTO `position_info_v2` VALUES (97, 1, '0001', 'CTO', '03', '西安市', '50-80k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:23:13');
INSERT INTO `position_info_v2` VALUES (98, 1, '0001', 'CTO', '03', '武汉市', '50-80k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:23:16');
INSERT INTO `position_info_v2` VALUES (99, 2, '0002', 'CTO', '03', '武汉市', '100-200k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:23:23');
INSERT INTO `position_info_v2` VALUES (100, 3, '0003', '销售总监', '04', '武汉市', '100-200k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:23:31');
INSERT INTO `position_info_v2` VALUES (101, 4, '0004', 'golang', '01', '武汉市', '100-200k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:23:32');
INSERT INTO `position_info_v2` VALUES (102, 1, '0003', '销售总监', '04', '武汉市', '100-200k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:23:34');
INSERT INTO `position_info_v2` VALUES (103, 1, '0005', '技工', '10', '武汉市', '100-200k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:23:36');
INSERT INTO `position_info_v2` VALUES (104, 1, '0001', 'CTO', '03', '武汉市', '30-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:23:45');
INSERT INTO `position_info_v2` VALUES (105, 1, '0001', 'CTO', '03', '武汉市', '30-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:24:05');
INSERT INTO `position_info_v2` VALUES (106, 1, '0001', 'CTO', '03', '广州市', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:24:09');
INSERT INTO `position_info_v2` VALUES (107, 2, '0002', 'CTO', '03', '广州市', '10-20k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:24:17');
INSERT INTO `position_info_v2` VALUES (108, 3, '0003', '销售总监', '04', '广州市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:24:22');
INSERT INTO `position_info_v2` VALUES (109, 4, '0004', 'golang', '01', '广州市', '10-20k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:24:24');
INSERT INTO `position_info_v2` VALUES (110, 1, '0003', '销售总监', '04', '广州市', '33-50k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:24:29');
INSERT INTO `position_info_v2` VALUES (111, 1, '0005', '技工', '10', '广州市', '33-50k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:24:35');
INSERT INTO `position_info_v2` VALUES (112, 1, '0001', 'CTO', '03', '广州市', '33-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:24:36');
INSERT INTO `position_info_v2` VALUES (113, 1, '0001', 'CTO', '03', '广州市', '33-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:24:38');
INSERT INTO `position_info_v2` VALUES (114, 1, '0001', 'CTO', '03', '深圳市', '230-300k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:24:55');
INSERT INTO `position_info_v2` VALUES (115, 2, '0002', 'CTO', '03', '深圳市', '230-300k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:25:01');
INSERT INTO `position_info_v2` VALUES (116, 3, '0003', '销售总监', '04', '深圳市', '230-300k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:25:07');
INSERT INTO `position_info_v2` VALUES (117, 4, '0004', 'golang', '01', '深圳市', '230-300k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:25:09');
INSERT INTO `position_info_v2` VALUES (118, 1, '0003', '销售总监', '04', '深圳市', '230-300k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:25:11');
INSERT INTO `position_info_v2` VALUES (119, 1, '0005', '技工', '10', '深圳市', '50-100k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:25:18');
INSERT INTO `position_info_v2` VALUES (120, 1, '0001', 'CTO', '03', '深圳市', '30-80k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:25:25');
INSERT INTO `position_info_v2` VALUES (121, 1, '0001', 'CTO', '03', '深圳市', '30-80k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:25:52');
INSERT INTO `position_info_v2` VALUES (122, 1, '0001', 'CTO', '03', '厦门市', '30-80k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:25:54');
INSERT INTO `position_info_v2` VALUES (123, 2, '0002', 'CTO', '03', '厦门市', '30-80k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:25:56');
INSERT INTO `position_info_v2` VALUES (124, 3, '0003', '销售总监', '04', '厦门市', '20-40k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:26:03');
INSERT INTO `position_info_v2` VALUES (125, 4, '0004', 'golang', '01', '厦门市', '20-40k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:26:09');
INSERT INTO `position_info_v2` VALUES (126, 1, '0003', '销售总监', '04', '厦门市', '20-40k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:14');
INSERT INTO `position_info_v2` VALUES (127, 1, '0005', '技工', '10', '厦门市', '20-40k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:16');
INSERT INTO `position_info_v2` VALUES (128, 1, '0001', 'CTO', '03', '厦门市', '20-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:18');
INSERT INTO `position_info_v2` VALUES (129, 1, '0001', 'CTO', '03', '厦门市', '20-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:20');
INSERT INTO `position_info_v2` VALUES (130, 1, '0001', 'CTO', '03', '南宁市', '20-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:25');
INSERT INTO `position_info_v2` VALUES (131, 2, '0002', 'CTO', '03', '南宁市', '20-40k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:26:26');
INSERT INTO `position_info_v2` VALUES (132, 3, '0003', '销售总监', '04', '南宁市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:26:30');
INSERT INTO `position_info_v2` VALUES (133, 4, '0004', 'golang', '01', '南宁市', '10-20k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:26:37');
INSERT INTO `position_info_v2` VALUES (134, 1, '0003', '销售总监', '04', '南宁市', '10-20k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:39');
INSERT INTO `position_info_v2` VALUES (135, 1, '0005', '技工', '10', '南宁市', '10-20k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:40');
INSERT INTO `position_info_v2` VALUES (136, 1, '0001', 'CTO', '03', '南宁市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:42');
INSERT INTO `position_info_v2` VALUES (137, 1, '0001', 'CTO', '03', '南宁市', '10-20k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:44');
INSERT INTO `position_info_v2` VALUES (138, 1, '0001', 'CTO', '03', '长沙市', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:26:49');
INSERT INTO `position_info_v2` VALUES (139, 2, '0002', 'CTO', '03', '长沙市', '20-30k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:26:56');
INSERT INTO `position_info_v2` VALUES (140, 3, '0003', '销售总监', '04', '长沙市', '20-30k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:26:57');
INSERT INTO `position_info_v2` VALUES (141, 4, '0004', 'golang', '01', '长沙市', '20-30k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:26:59');
INSERT INTO `position_info_v2` VALUES (142, 1, '0003', '销售总监', '04', '长沙市', '20-30k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:00');
INSERT INTO `position_info_v2` VALUES (143, 1, '0005', '技工', '10', '长沙市', '20-30k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:02');
INSERT INTO `position_info_v2` VALUES (144, 1, '0001', 'CTO', '03', '长沙市', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:03');
INSERT INTO `position_info_v2` VALUES (145, 1, '0001', 'CTO', '03', '长沙市', '20-30k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:05');
INSERT INTO `position_info_v2` VALUES (146, 1, '0001', 'CTO', '03', '南京市', '20-40k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:10');
INSERT INTO `position_info_v2` VALUES (147, 2, '0002', 'CTO', '03', '南京市', '10-20k', '15', '研究生', '研发', '03', '张三', 'HR', '2020-10-21', '2020-10-24 03:27:17');
INSERT INTO `position_info_v2` VALUES (148, 3, '0003', '销售总监', '04', '南京市', '10-20k', '10', '研究生', '销售', '04', '张丰', 'HR', '2020-10-21', '2020-10-24 03:27:22');
INSERT INTO `position_info_v2` VALUES (149, 4, '0004', 'golang', '01', '南京市', '30-40k', '5', '本科', '研发', '03', '赵四', 'HR', '2020-10-21', '2020-10-24 03:27:27');
INSERT INTO `position_info_v2` VALUES (150, 1, '0003', '销售总监', '04', '南京市', '30-50k', '10', '本科', '销售', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:33');
INSERT INTO `position_info_v2` VALUES (151, 1, '0005', '技工', '10', '南京市', '20-40k', '5', '高中', '普工', '06', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:39');
INSERT INTO `position_info_v2` VALUES (152, 1, '0001', 'CTO', '03', '南京市', '40-100k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:27:45');
INSERT INTO `position_info_v2` VALUES (153, 1, '0001', 'CTO', '03', '南京市', '30-50k', '10', '本科', '研发', '03', '张三丰', 'HR', '2020-10-21', '2020-10-24 03:28:28');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
